Tabela System

Definicja tabeli System

Name

System

Code

System

Comment

 


Lista kolumn tabeli System

Name

Code

SystemID

SystemID

SysIOID

SysIOID

PersonID

PersonID

ShortName

ShortName

FullName

FullName

Description

Description

Active

Active

Comments

Comments


Kolumna SystemID tabeli System

Definicja kolumny SystemID tabeli System

Name

SystemID

Code

SystemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SysIOID tabeli System

Definicja kolumny SysIOID tabeli System

Name

SysIOID

Code

SysIOID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli System

Definicja kolumny PersonID tabeli System

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli System

Definicja kolumny ShortName tabeli System

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli System

Definicja kolumny FullName tabeli System

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli System

Definicja kolumny Description tabeli System

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Active tabeli System

Definicja kolumny Active tabeli System

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Comments tabeli System

Definicja kolumny Comments tabeli System

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli System

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli System

Definicja klucza Identifier_1 tabeli System

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment